Use BD_SYS_ALMACEN
Go
Create Procedure dbo.GRCategoria_Obtener(
   @iCodCat Int
)
As
Begin

   Select 
      iCodCat, 
      vNomCat,
      vDesCat,
      bActivoEst,
      iCodUsu,
      vNomTer,
      dtFecAct
   From GRCategoria a(Nolock)   
   Where iCodCat = @iCodCat
   
End